<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/9/12
 * Time: 10:27
 * 查询订单根据学生id分组
 */
$oo_oesid = $route->bodyParams['oo_oesid'];  //参与者ID
$start_time = $route->bodyParams['start_time'];  //参与者ID
$end_time = $route->bodyParams['end_time'];  //参与者ID

//

/*$sql = "SELECT * FROM art_oa_order where oo_oesid =" .$oa_oseid." GROUP BY oo_osid";*/
$sql = "SELECT COUNT(oo_id) as oo_id FROM art_oa_order where oo_oesid =".$oo_oesid." AND oo_create_time BETWEEN ".$start_time." AND ".$end_time." GROUP BY oo_osid ;";

//$sql  = "SELECT oc_limit_number from art_oa_classroom WHERE oc_oesid = ".$oa_oseid;
$re=$db->mysqlDB->query($sql);

$response->responseData(true, $re);